StudentSubsidiaryAccountTransaction 
EntityType  Independent 
Logical Entity Name  StudentSubsidiaryAccountTransaction 
Default Table Name  SaStudSubsidiaryTrans 
Logical Only  NO 
Definition 
 
Note 
 

StudentSubsidiaryAccountTransaction Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentSubsidiaryAccountTransactionId(PK)    INTEGER  NO 
 
TransactionNumber    SMALLINT  NO 
 
Description    VARCHAR(50)  NO 
 
BillingTransactionCode    VARCHAR(8)  NO 
 
StudentSubsidiaryAccountId(FK)    INTEGER  NO 
 
CampusId(FK)    INTEGER  YES 
 
BillingTransactionCodeId(FK)    INTEGER  YES 
 
TransactionDate    DATETIME  NO 
 
Reference    CHAR(23)  NO 
 
CheckNumber    VARCHAR(20)  YES 
 
BankAccountId(FK)    INTEGER  YES 
 
Amount    MONEY(19, 4)  NO 
 
AcademicYearSequence    SMALLINT  YES 
 
TermId(FK)    INTEGER  YES 
 
Type    CHAR(1)  NO 
 
IsPostedToGeneralLedger    BIT  NO 
 
StudentCreditCardId(FK)    INTEGER  YES 
 
BankDepositId(FK)    INTEGER  YES 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
StudentSubsidiaryAccountRefundId(FK)    INTEGER  YES 
 
PaymentType    CHAR(1)  YES 
 
ReceiptNumber    CHAR(16)  YES 
 
CreditCardAuthorizationNumber    CHAR(10)  YES 
 
CreditCardDeclineCode    CHAR(10)  YES 
 
CashDrawerSessionId(FK)    INTEGER  YES 
 
IsSentBack    BIT  NO 
 
Source    CHAR(1)  NO 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
CheckStatus    CHAR(1)  NO 
 
CheckDate    DATETIME  YES 
 
EFTNumber    VARCHAR(20)  YES 
 
EFTStatus    CHAR(1)  YES 
 
EFTClearedDate    DATETIME  YES 
 
IsGeneralLedgerStatusFlag    BIT  NO 
 
IsInPendingQueue    BIT  NO 
 
OriginalSaStudSubsidiaryTransID    INTEGER  YES 
 
IsReIssue    BIT  NO 
 
CashDrawerSessionId(FK)    INTEGER  YES 
 
StudentCreditCardId(FK)    INTEGER  YES 
 

StudentSubsidiaryAccountTransaction Keys 
Key Name  Key Type  Keys 
SaStudSubsidiaryTrans_AdTermID_SaStudSubsidiaryTransID_U_N_IDX  Alternate Key  TermId, StudentSubsidiaryAccountTransactionId 
SaStudSubsidiaryTrans_SaStudSubsidiaryID_SaStudSubsidiaryTransID_U_N_IDX  Alternate Key  StudentSubsidiaryAccountId, StudentSubsidiaryAccountTransactionId 
SaStudSubsidiaryTrans_SaSubsidiaryRefundID_SaStudSubsidiaryTransID_U_N_IDX  Alternate Key  StudentSubsidiaryAccountRefundId, StudentSubsidiaryAccountTransactionId 
SaStudSubsidiaryTrans_SaCCID_N_N_IDX  Inversion Entry  StudentCreditCardId 
SaStudSubsidiaryTrans_SaCashDrawerSessionID_N_N_IDX  Inversion Entry  CashDrawerSessionId 
SaStudSubsidiaryTrans_SaBillCodeID_N_N_IDX  Inversion Entry  BillingTransactionCodeId 
SaStudSubsidiaryTrans_SaBankDepID_N_N_IDX  Inversion Entry  BankDepositId 
SaStudSubsidiaryTrans_SaStudSubsidiaryTransID_U_C_IDX  PrimaryKey  StudentSubsidiaryAccountTransactionId 
SaStudSubsidiaryTrans_SaBankAccountID_N_N_IDX  Inversion Entry  BankAccountId 
SaStudSubsidiaryTrans_SyAddressID_N_N_IDX  Inversion Entry  StudentRelationshipAddressId 
SaStudSubsidiaryTrans_UserID_SaStudSubsidiaryTransID_U_N_IDX  Alternate Key  LastModifiedUserId, StudentSubsidiaryAccountTransactionId 
SaStudSubsidiaryTrans_SyCampusID_SaStudSubsidiaryTransID_U_N_IDX  Alternate Key  CampusId, StudentSubsidiaryAccountTransactionId 

StudentSubsidiaryAccountTransaction Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
BankDeposit  Non-Identifying  Zero or One to Zero or More        BankDepositId  NO 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        BillingTransactionCodeId  NO 
Campus  Non-Identifying  Zero or One to Zero or More        CampusId  NO 
CashDrawerSession  Non-Identifying  Zero or One to Zero or More        CashDrawerSessionId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
BankDeposit  Non-Identifying  Zero or One to Zero or More        BankDepositId  NO 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        BillingTransactionCodeId  NO 
CashDrawerSession  Non-Identifying  Zero or One to Zero or More        CashDrawerSessionId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentSubsidiaryAccount  Non-Identifying  One To Zero or More        StudentSubsidiaryAccountId  NO 
StudentSubsidiaryAccountRefund  Non-Identifying  Zero or One to Zero or More        StudentSubsidiaryAccountRefundId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
Campus  Non-Identifying  Zero or One to Zero or More        CampusId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
StudentSubsidiaryAccount  Non-Identifying  Zero or One to Zero or More        StudentSubsidiaryAccountId  NO 
StudentSubsidiaryAccountRefund  Non-Identifying  Zero or One to Zero or More        StudentSubsidiaryAccountRefundId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
GeneralLedgerReleaseBatchDetail  Non-Identifying  One To Zero or More          NO 
GeneralLedgerReleaseBatchDetail  Non-Identifying  One To Zero or More          NO 

StudentSubsidiaryAccountTransaction Check Constraints 
Check Constraint Name  CheckConstraint